set pagesize 0
set long  1000000
SELECT get_table_md FROM dual;


--You can accomplish the same effect with the browsing interface:
SELECT dbms_metadata.get_ddl
      ('TABLE','ORDERS','OE') 
FROM dual;
